# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月19日
"""
import openpyxl

myBook = openpyxl.load_workbook('收入表.xlsx')
mySheet = myBook['收入表']

myIndex = 2
for myCol in list(mySheet.columns)[1:]:
	mySum = sum([myCell.value for myCell in myCol[4:8]])
	mySheet.cell(9, myIndex).value = mySum
	myIndex += 1

myBook.save('收入表.xlsx')
